Previous Topic

Next Topic

Additional Special Pricing Examples

In many cases, there may be alternative methods for implementing a special pricing scenario. For example, most table/step special pricing methods could be defined through one or more SQL statements. SQL statements are less limiting (not restricted to 20 table levels) and may make the dues billing run more efficiently.

To demonstrate the alternative methods of special pricing implementation, the following examples show the alternative table compared to SQL statements for a simple sliding-scale type billing structure.

Special Pricing Scenario 1

For example, an organization with two staff members would be charged $380 [$350 base rate + (2x$15)]. A company with 15 employees would be charged $550 [$500 + (5x$10)].

Special Pricing window - Numeric Table example

If your system supports the CASE statement (for example, iMIS for Microsoft SQL running under Microsoft SQL Server version 7 or later), you can implement special pricing with an SQL CASE statement by selecting the Amount from field option.

Special Pricing window- SQL CASE Statement example

Note: Press Ctrl+Z to view the entire source field.

Expanded Source Field showing SQL CASE Statement

If your system supports IF statement logic (for example, most iMIS for Sybase Adaptive Server Anywhere), you can implement the special pricing with an IF statement by selecting the Amount from field option and entering the IF statement in the Source Field that displays.

Special Pricing window - SQL IF statement example

Expanded Source Field showing SQL IF Statement

Special Pricing Scenario 2

Set up an initiation for all new customers. In this example, special pricing is based on the JOIN_DATE in order to bill the customer only once. In 1999, the initiation fee would be $50. In 2000, the fee would have increased to $55, and then increased again in 2001 to $57.50.

The first step is to set up a MISC product code.

From Billing, select Set up module > Products

On the Special Pricing window, the Amount from field option is selected.

The following formula is entered in Source Field.

Note: The dates will need to be adjusted for the years the initiation fees will be applied to. Notice that the date format is yyyy/mm/dd.

If Name_All.JOIN_DATE >= '1999/01/01' and Name_All.JOIN_DATE <= '1999/12/31' THEN 50
ELSE IF Name_All.JOIN_DATE >= '2000/01/01' and Name_All.JOIN_DATE <= '2000/12/31' THEN 55
ELSE IF Name_All.JOIN_DATE >= '2001/01/01' and Name_All.JOIN_DATE <= '2001/12/31' THEN 57.50
ENDIF
ENDIF
ENDIF

Note: The MISC-INITIATE product code should also be added to the Set up customer types window (from Customers, select Set up module > Customer types) for the BASIC dues product.

See Also

Special Pricing Examples

Flat amount price

Pricing based on an iMIS field

Pricing based on a numeric table

To define pricing based on an alpha table

Define matching based on exact match


ASI logo 10.5 Production Release. Updated 2/23/2006 1:43:19 PM
Copyright © by Advanced Solutions International, Inc. All rights reserved.